package cn.example.freid.util;

public class SQLStrings {
	
	static public final String ADD_SQL = "INSERT INTO EXAMPLE_DOMAIN"
			+ "("
			+ "NAME,"
			+ "ID,"
			+ "MAIL,"
			+ "COMMENTS"
			+ ")"
			+ "VALUES(?,?,?,?)";
	
	static public final String DELETE_SQL = "DELETE FROM EXAMPLE_DOMAIN t "
			+ "WHERE t.ID = ?";
	
	static public final String MOD_SQL = "UPDATE EXAMPLE_DOMAIN "
			+ "SET NAME = ?, "
			+ "MAIL = ?, "
			+ "COMMENTS = ? "
			+ "WHERE ID = ?";
	
	static public final String QUERY_ALL_SQL = "SELECT * FROM EXAMPLE_DOMAIN";
	
	static public final String QUERY_BYID_SQL = "SELECT * FROM EXAMPLE_DOMAIN "
			+ "WHERE ID = ?";

	static public final String QUERY_BYPAGE_SQL = "SELECT * FROM EXAMPLE_DOMAIN LIMIT ?,?";
	
	static public final String QUERY_COUNT_SQL = "SELECT COUNT(*) FROM EXAMPLE_DOMAIN";
}
